Export Wizard allows you to export data from table, view, or query results to any available format. You can save your settings as a profile for setting schedule.
Note: Navicat Lite version supports to export text-based files, such as TXT, CSV and XML file.
To open the export wizard (see Table Viewer, Query and View Viewer (MySQL, Oracle, PostgreSQL, SQLite or SQL Server) for details)
- Setting Export File Format
- Setting Destination File Paths and Encoding
- Selecting Table Columns for Export
- Setting Additional Options
- Saving and Confirming Export
To run a saved export profile from the command line
- Create and save the export profile.
- In terminal, type the command (see Command for details)
See also:
Dumping SQL File
Import Wizard